Re: SERIAL Field - Mailing list pgsql-admin

From Joel Stevenson
Subject Re: SERIAL Field
Date
Msg-id a05111709b8fc88c96775@[192.168.1.100]
Whole thread Raw
In response to Re: SERIAL Field  ("Dan Langille" <dan@langille.org>)
Responses Re: SERIAL Field
List pgsql-admin
>  > "You say nextval() + write, I say write + currval()..."
>
>So long as a given application does not mix the two approaches, everything
>should be fine.

Though, if you have multiple clients inserting into the table, there
is a chance that between client A inserting the record and then
calling currval(), client B could have performed an insert, in which
case client A gets the value of client B's record.  'nextval() +
write' avoids this possible overlap.
--
Joel Stevenson
Bear River Associates, Inc.

pgsql-admin by date:

Previous
From: Brian McCane
Date:
Subject: Re: SERIAL Field
Next
From: Tom Lane
Date:
Subject: Re: SERIAL Field